object ParcaDegisimFisleriF: TParcaDegisimFisleriF
  Left = 160
  Top = 109
  Width = 829
  Height = 571
  Caption = 'Par'#231'a De'#287'i'#351'im Fi'#351'leri'
  Color = clBtnFace
  Font.Charset = TURKISH_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'Arial'
  Font.Style = []
  OldCreateOrder = False
  Position = poDefaultPosOnly
  OnClose = FormClose
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 14
  object Bevel2: TBevel
    Left = 5
    Top = 15
    Width = 633
    Height = 9
    Shape = bsTopLine
  end
  object Bevel1: TBevel
    Left = 5
    Top = 175
    Width = 633
    Height = 9
    Shape = bsTopLine
  end
  object Bevel3: TBevel
    Left = 5
    Top = 335
    Width = 633
    Height = 9
    Shape = bsTopLine
  end
  object StaticText1: TStaticText
    Left = 20
    Top = 9
    Width = 78
    Height = 18
    Caption = #220'retim Fi'#351'leri'
    Font.Charset = TURKISH_CHARSET
    Font.Color = 13977088
    Font.Height = -11
    Font.Name = 'Arial'
    Font.Style = [fsBold]
    ParentFont = False
    TabOrder = 0
  end
  object K: TwwDBGrid
    Left = 8
    Top = 27
    Width = 628
    Height = 134
    DisableThemes = False
    Selected.Strings = (
      'StokFisiid'#9'10'#9'Fi'#351' No'#9'F'
      'stokkodu'#9'25'#9'Stok Kodu'#9'F'
      'cinsi'#9'30'#9'Cinsi'#9'F'
      'gambar'#9'22'#9'G.Ambar'#9'F'
      'miktar'#9'8'#9'Miktar'#9'F')
    IniAttributes.Delimiter = ';;'
    TitleColor = clBtnFace
    FixedCols = 0
    ShowHorzScrollBar = True
    DataSource = UretimQS
    Font.Charset = TURKISH_CHARSET
    Font.Color = clWindowText
    Font.Height = -11
    Font.Name = 'Arial'
    Font.Style = []
    KeyOptions = []
    Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit, dgWordWrap]
    ParentFont = False
    TabOrder = 1
    TitleAlignment = taLeftJustify
    TitleFont.Charset = TURKISH_CHARSET
    TitleFont.Color = clBlack
    TitleFont.Height = -11
    TitleFont.Name = 'Arial'
    TitleFont.Style = []
    TitleLines = 1
    TitleButtons = False
    UseTFields = False
  end
  object StaticText2: TStaticText
    Left = 20
    Top = 169
    Width = 63
    Height = 18
    Caption = 'Sarf Fi'#351'leri'
    Font.Charset = TURKISH_CHARSET
    Font.Color = 13977088
    Font.Height = -11
    Font.Name = 'Arial'
    Font.Style = [fsBold]
    ParentFont = False
    TabOrder = 2
  end
  object wwDBGrid1: TwwDBGrid
    Left = 8
    Top = 187
    Width = 628
    Height = 134
    DisableThemes = False
    Selected.Strings = (
      'StokFisiid'#9'10'#9'Fi'#351' No'#9'F'
      'stokkodu'#9'25'#9'Stok Kodu'#9'F'
      'cinsi'#9'30'#9'Cinsi'#9'F'
      'cambar'#9'22'#9#199#305'k'#305#351' Ambar'#9'F'
      'miktar'#9'8'#9'Miktar'#9'F')
    IniAttributes.Delimiter = ';;'
    TitleColor = clBtnFace
    FixedCols = 0
    ShowHorzScrollBar = True
    DataSource = SarfQS
    Font.Charset = TURKISH_CHARSET
    Font.Color = clWindowText
    Font.Height = -11
    Font.Name = 'Arial'
    Font.Style = []
    KeyOptions = []
    Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit, dgWordWrap]
    ParentFont = False
    TabOrder = 3
    TitleAlignment = taLeftJustify
    TitleFont.Charset = TURKISH_CHARSET
    TitleFont.Color = clBlack
    TitleFont.Height = -11
    TitleFont.Name = 'Arial'
    TitleFont.Style = []
    TitleLines = 1
    TitleButtons = False
    UseTFields = False
  end
  object StaticText3: TStaticText
    Left = 20
    Top = 329
    Width = 120
    Height = 18
    Caption = 'Depo Transfer Fi'#351'leri'
    Font.Charset = TURKISH_CHARSET
    Font.Color = 13977088
    Font.Height = -11
    Font.Name = 'Arial'
    Font.Style = [fsBold]
    ParentFont = False
    TabOrder = 4
  end
  object wwDBGrid2: TwwDBGrid
    Left = 8
    Top = 347
    Width = 627
    Height = 134
    DisableThemes = False
    Selected.Strings = (
      'StokFisiid'#9'10'#9'Fi'#351' No'#9'F'
      'stokkodu'#9'25'#9'Stok Kodu'#9'F'
      'cinsi'#9'30'#9'Cinsi'#9'F'
      'cambar'#9'11'#9#199#305'k'#305#351' Ambar'#9'F'
      'gambar'#9'11'#9'G.Ambar'#9'F'
      'miktar'#9'7'#9'Miktar'#9'F')
    IniAttributes.Delimiter = ';;'
    TitleColor = clBtnFace
    FixedCols = 0
    ShowHorzScrollBar = True
    DataSource = DepoTransferQS
    Font.Charset = TURKISH_CHARSET
    Font.Color = clWindowText
    Font.Height = -11
    Font.Name = 'Arial'
    Font.Style = []
    KeyOptions = []
    Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit, dgWordWrap]
    ParentFont = False
    TabOrder = 5
    TitleAlignment = taLeftJustify
    TitleFont.Charset = TURKISH_CHARSET
    TitleFont.Color = clBlack
    TitleFont.Height = -11
    TitleFont.Name = 'Arial'
    TitleFont.Style = []
    TitleLines = 1
    TitleButtons = False
    UseTFields = False
  end
  object Panel1: TPanel
    Left = 0
    Top = 506
    Width = 821
    Height = 38
    Align = alBottom
    BevelOuter = bvNone
    TabOrder = 6
    DesignSize = (
      821
      38)
    object blistele: TButton
      Left = 8
      Top = 8
      Width = 89
      Height = 25
      Caption = 'Listele'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 0
      OnClick = blisteleClick
    end
    object byazdir: TButton
      Left = 112
      Top = 8
      Width = 89
      Height = 25
      Caption = 'Yazd'#305'r'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 1
      OnClick = byazdirClick
    end
    object Button1: TButton
      Left = 724
      Top = 8
      Width = 89
      Height = 25
      Anchors = [akRight, akBottom]
      Caption = 'Kapat'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 2
      OnClick = Button1Click
    end
  end
  object wwDBGrid3: TwwDBGrid
    Left = 0
    Top = 224
    Width = 641
    Height = 120
    DisableThemes = False
    IniAttributes.Delimiter = ';;'
    TitleColor = clBtnFace
    FixedCols = 0
    ShowHorzScrollBar = True
    DataSource = UretimEskiQS
    TabOrder = 7
    TitleAlignment = taLeftJustify
    TitleFont.Charset = TURKISH_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'Arial'
    TitleFont.Style = []
    TitleLines = 1
    TitleButtons = False
    Visible = False
  end
  object wwDBGrid4: TwwDBGrid
    Left = 0
    Top = 376
    Width = 643
    Height = 120
    DisableThemes = False
    IniAttributes.Delimiter = ';;'
    TitleColor = clBtnFace
    FixedCols = 0
    ShowHorzScrollBar = True
    DataSource = SarfEskiQS
    TabOrder = 8
    TitleAlignment = taLeftJustify
    TitleFont.Charset = TURKISH_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'Arial'
    TitleFont.Style = []
    TitleLines = 1
    TitleButtons = False
    Visible = False
  end
  object UretimQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <>
    SQL.Strings = (
      
        'select StokFisiid,stokkod,dbo.getstokkodu(stokkod) as stokkodu,d' +
        'bo.getcinsi(stokkod) as cinsi,miktar,gambar=(select depoadi from' +
        ' depolar where depolar.id=stokfisihar.gambar) from stokfisihar'
      'where stokfisiid in'
      '('
      'select id from stokfisi'
      
        'where fistipi='#39'01'#39' and ozeltip is not null and ozeltip<>'#39'ekp'#39' an' +
        'd ozeltip<>'#39'arz'#39
      ')'
      'order by StokFisiid,stokkodu,miktar')
    Left = 688
    Top = 25
  end
  object UretimQS: TDataSource
    DataSet = UretimQ
    Left = 648
    Top = 25
  end
  object SarfQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <>
    SQL.Strings = (
      
        'select StokFisiid,stokkod,dbo.getstokkodu(stokkod) as stokkodu,d' +
        'bo.getcinsi(stokkod) as cinsi,miktar,cambar=(select depoadi from' +
        ' depolar where depolar.id=stokfisihar.cambar) from stokfisihar'
      'where stokfisiid in'
      '('
      'select id from stokfisi'
      
        'where fistipi='#39'21'#39' and ozeltip is not null and ozeltip<>'#39'ekp'#39' an' +
        'd ozeltip<>'#39'arz'#39
      ')'
      'order by StokFisiid,stokkodu,miktar')
    Left = 688
    Top = 89
  end
  object SarfQS: TDataSource
    DataSet = SarfQ
    Left = 648
    Top = 89
  end
  object DepoTransferQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <>
    SQL.Strings = (
      
        'select StokFisiid,stokkod,dbo.getstokkodu(stokkod) as stokkodu,d' +
        'bo.getcinsi(stokkod) as cinsi,miktar,cambar=(select depoadi from' +
        ' depolar where depolar.id=stokfisihar.cambar),gambar=(select dep' +
        'oadi from depolar where depolar.id=stokfisihar.gambar)  from sto' +
        'kfisihar'
      'where stokfisiid in'
      '('
      'select id from stokfisi'
      
        'where fistipi='#39'61'#39' and ozeltip is not null and ozeltip<>'#39'ekp'#39' an' +
        'd ozeltip<>'#39'arz'#39
      ')'
      'order by StokFisiid,stokkodu,miktar')
    Left = 688
    Top = 145
  end
  object DepoTransferQS: TDataSource
    DataSet = DepoTransferQ
    Left = 648
    Top = 145
  end
  object RepUretim: TppReport
    AutoStop = False
    DataPipeline = ppUretim
    PrinterSetup.BinName = 'Default'
    PrinterSetup.DocumentName = 'Report'
    PrinterSetup.PaperName = 'A4'
    PrinterSetup.PrinterName = 'Default'
    PrinterSetup.mmMarginBottom = 6350
    PrinterSetup.mmMarginLeft = 6350
    PrinterSetup.mmMarginRight = 6350
    PrinterSetup.mmMarginTop = 6350
    PrinterSetup.mmPaperHeight = 297000
    PrinterSetup.mmPaperWidth = 210000
    PrinterSetup.PaperSize = 9
    Units = utMillimeters
    AllowPrintToFile = True
    DeviceType = 'Screen'
    EmailSettings.ReportFormat = 'PDF'
    OutlineSettings.CreateNode = False
    OutlineSettings.CreatePageNodes = False
    OutlineSettings.Enabled = False
    OutlineSettings.Visible = False
    PreviewFormSettings.WindowState = wsMaximized
    PreviewFormSettings.ZoomSetting = zs100Percent
    TextSearchSettings.DefaultString = '<FindText>'
    TextSearchSettings.Enabled = False
    Left = 784
    Top = 24
    Version = '10.02'
    mmColumnWidth = 197300
    DataPipelineName = 'ppUretim'
    object ppTitleBand1: TppTitleBand
      mmBottomOffset = 0
      mmHeight = 7938
      mmPrintPosition = 0
      object ppLabel1: TppLabel
        UserName = 'Label1'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = #220'retim Fi'#351'leri'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 12
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4763
        mmLeft = 1323
        mmTop = 1323
        mmWidth = 59796
        BandType = 1
      end
    end
    object ppHeaderBand1: TppHeaderBand
      mmBottomOffset = 0
      mmHeight = 7408
      mmPrintPosition = 0
      object ppLine1: TppLine
        UserName = 'Line1'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Pen.Color = clNavy
        Pen.Width = 2
        Weight = 1.500000000000000000
        mmHeight = 3969
        mmLeft = 1323
        mmTop = 6350
        mmWidth = 194734
        BandType = 0
      end
      object ppLabel2: TppLabel
        UserName = 'Label2'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Stok Kodu'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Times New Roman'
        Font.Size = 10
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4233
        mmLeft = 19844
        mmTop = 1323
        mmWidth = 19579
        BandType = 0
      end
      object ppLabel4: TppLabel
        UserName = 'Label3'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Cinsi'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Times New Roman'
        Font.Size = 10
        Font.Style = [fsBold, fsItalic]
        Transparent = True
        mmHeight = 4233
        mmLeft = 61913
        mmTop = 1323
        mmWidth = 8731
        BandType = 0
      end
      object ppLabel5: TppLabel
        UserName = 'Label4'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Miktar'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Times New Roman'
        Font.Size = 10
        Font.Style = [fsBold, fsItalic]
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 4233
        mmLeft = 107950
        mmTop = 1323
        mmWidth = 12700
        BandType = 0
      end
      object ppLabel6: TppLabel
        UserName = 'Label5'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Giri'#351' Ambar'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Times New Roman'
        Font.Size = 10
        Font.Style = [fsBold, fsItalic]
        Transparent = True
        mmHeight = 4233
        mmLeft = 123031
        mmTop = 1323
        mmWidth = 25929
        BandType = 0
      end
      object ppLabel7: TppLabel
        UserName = 'Label6'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Fi'#351' No'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Times New Roman'
        Font.Size = 10
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4233
        mmLeft = 2117
        mmTop = 1323
        mmWidth = 16933
        BandType = 0
      end
    end
    object ppDetailBand1: TppDetailBand
      mmBottomOffset = 0
      mmHeight = 5027
      mmPrintPosition = 0
      object ppDBText1: TppDBText
        UserName = 'DBText1'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'stokkodu'
        DataPipeline = ppUretim
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppUretim'
        mmHeight = 3440
        mmLeft = 19844
        mmTop = 529
        mmWidth = 40746
        BandType = 4
      end
      object ppDBText3: TppDBText
        UserName = 'DBText2'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'cinsi'
        DataPipeline = ppUretim
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppUretim'
        mmHeight = 3440
        mmLeft = 61913
        mmTop = 529
        mmWidth = 40746
        BandType = 4
      end
      object ppDBText4: TppDBText
        UserName = 'DBText3'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'miktar'
        DataPipeline = ppUretim
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        DataPipelineName = 'ppUretim'
        mmHeight = 3440
        mmLeft = 103981
        mmTop = 529
        mmWidth = 16933
        BandType = 4
      end
      object ppDBText5: TppDBText
        UserName = 'DBText5'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'gambar'
        DataPipeline = ppUretim
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppUretim'
        mmHeight = 3440
        mmLeft = 123031
        mmTop = 529
        mmWidth = 32808
        BandType = 4
      end
      object ppLine7: TppLine
        UserName = 'Line3'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Weight = 0.750000000000000000
        mmHeight = 529
        mmLeft = 1323
        mmTop = 4498
        mmWidth = 155575
        BandType = 4
      end
      object ppDBText6: TppDBText
        UserName = 'DBText4'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'StokFisiid'
        DataPipeline = ppUretim
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppUretim'
        mmHeight = 3440
        mmLeft = 2381
        mmTop = 529
        mmWidth = 15875
        BandType = 4
      end
    end
    object ppFooterBand1: TppFooterBand
      mmBottomOffset = 0
      mmHeight = 7144
      mmPrintPosition = 0
      object ppLine4: TppLine
        UserName = 'Line2'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Pen.Color = clGray
        Pen.Width = 2
        Weight = 1.500000000000000000
        mmHeight = 3969
        mmLeft = 1323
        mmTop = 5821
        mmWidth = 194734
        BandType = 8
      end
      object ppSystemVariable1: TppSystemVariable
        UserName = 'SystemVariable1'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        VarType = vtPrintDateTime
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 9
        Font.Style = []
        Transparent = True
        mmHeight = 3704
        mmLeft = 1323
        mmTop = 1323
        mmWidth = 26458
        BandType = 8
      end
      object ppSystemVariable2: TppSystemVariable
        UserName = 'SystemVariable2'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        VarType = vtPageNoDesc
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 9
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 3704
        mmLeft = 187537
        mmTop = 1323
        mmWidth = 8573
        BandType = 8
      end
    end
  end
  object ppUretim: TppDBPipeline
    DataSource = UretimQS
    AutoCreateFields = False
    UserName = 'Uretim'
    Left = 752
    Top = 24
  end
  object ppSarfQ: TppDBPipeline
    DataSource = SarfQS
    AutoCreateFields = False
    UserName = 'Uretim1'
    Left = 752
    Top = 64
  end
  object ppDepoTransfer: TppDBPipeline
    DataSource = DepoTransferQS
    AutoCreateFields = False
    UserName = 'DepoTransfer'
    Left = 752
    Top = 104
  end
  object RepSarf: TppReport
    AutoStop = False
    DataPipeline = ppSarfQ
    PrinterSetup.BinName = 'Default'
    PrinterSetup.DocumentName = 'Report'
    PrinterSetup.PaperName = 'A4'
    PrinterSetup.PrinterName = 'Default'
    PrinterSetup.mmMarginBottom = 6350
    PrinterSetup.mmMarginLeft = 6350
    PrinterSetup.mmMarginRight = 6350
    PrinterSetup.mmMarginTop = 6350
    PrinterSetup.mmPaperHeight = 297000
    PrinterSetup.mmPaperWidth = 210000
    PrinterSetup.PaperSize = 9
    Units = utMillimeters
    AllowPrintToFile = True
    DeviceType = 'Screen'
    EmailSettings.ReportFormat = 'PDF'
    OutlineSettings.CreateNode = False
    OutlineSettings.CreatePageNodes = False
    OutlineSettings.Enabled = False
    OutlineSettings.Visible = False
    PreviewFormSettings.WindowState = wsMaximized
    PreviewFormSettings.ZoomSetting = zs100Percent
    TextSearchSettings.DefaultString = '<FindText>'
    TextSearchSettings.Enabled = False
    Left = 784
    Top = 64
    Version = '10.02'
    mmColumnWidth = 197300
    DataPipelineName = 'ppSarfQ'
    object ppTitleBand2: TppTitleBand
      mmBottomOffset = 0
      mmHeight = 7938
      mmPrintPosition = 0
      object ppLabel3: TppLabel
        UserName = 'Label1'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Sarf Fi'#351'leri'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 12
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4763
        mmLeft = 1323
        mmTop = 1323
        mmWidth = 59796
        BandType = 1
      end
    end
    object ppHeaderBand2: TppHeaderBand
      mmBottomOffset = 0
      mmHeight = 7408
      mmPrintPosition = 0
      object ppLine2: TppLine
        UserName = 'Line1'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Pen.Color = clNavy
        Pen.Width = 2
        Weight = 1.500000000000000000
        mmHeight = 3969
        mmLeft = 1323
        mmTop = 6350
        mmWidth = 194734
        BandType = 0
      end
      object ppLabel8: TppLabel
        UserName = 'Label2'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Stok Kodu'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Times New Roman'
        Font.Size = 10
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4233
        mmLeft = 19844
        mmTop = 1323
        mmWidth = 19579
        BandType = 0
      end
      object ppLabel9: TppLabel
        UserName = 'Label3'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Cinsi'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Times New Roman'
        Font.Size = 10
        Font.Style = [fsBold, fsItalic]
        Transparent = True
        mmHeight = 4233
        mmLeft = 61913
        mmTop = 1323
        mmWidth = 8731
        BandType = 0
      end
      object ppLabel10: TppLabel
        UserName = 'Label4'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Miktar'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Times New Roman'
        Font.Size = 10
        Font.Style = [fsBold, fsItalic]
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 4233
        mmLeft = 107950
        mmTop = 1323
        mmWidth = 12700
        BandType = 0
      end
      object ppLabel11: TppLabel
        UserName = 'Label5'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = #199#305'k'#305#351' Ambar'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Times New Roman'
        Font.Size = 10
        Font.Style = [fsBold, fsItalic]
        Transparent = True
        mmHeight = 4233
        mmLeft = 123031
        mmTop = 1323
        mmWidth = 25929
        BandType = 0
      end
      object ppLabel12: TppLabel
        UserName = 'Label6'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Fi'#351' No'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Times New Roman'
        Font.Size = 10
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4233
        mmLeft = 2117
        mmTop = 1323
        mmWidth = 16933
        BandType = 0
      end
    end
    object ppDetailBand2: TppDetailBand
      mmBottomOffset = 0
      mmHeight = 5027
      mmPrintPosition = 0
      object ppDBText2: TppDBText
        UserName = 'DBText1'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'stokkodu'
        DataPipeline = ppSarfQ
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppSarfQ'
        mmHeight = 3440
        mmLeft = 19844
        mmTop = 529
        mmWidth = 40746
        BandType = 4
      end
      object ppDBText7: TppDBText
        UserName = 'DBText2'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'cinsi'
        DataPipeline = ppSarfQ
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppSarfQ'
        mmHeight = 3440
        mmLeft = 61913
        mmTop = 529
        mmWidth = 40746
        BandType = 4
      end
      object ppDBText8: TppDBText
        UserName = 'DBText3'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'miktar'
        DataPipeline = ppSarfQ
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        DataPipelineName = 'ppSarfQ'
        mmHeight = 3440
        mmLeft = 103981
        mmTop = 529
        mmWidth = 16933
        BandType = 4
      end
      object ppDBText9: TppDBText
        UserName = 'DBText5'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'cambar'
        DataPipeline = ppSarfQ
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppSarfQ'
        mmHeight = 3440
        mmLeft = 123031
        mmTop = 529
        mmWidth = 32808
        BandType = 4
      end
      object ppLine3: TppLine
        UserName = 'Line3'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Weight = 0.750000000000000000
        mmHeight = 529
        mmLeft = 1323
        mmTop = 4498
        mmWidth = 155575
        BandType = 4
      end
      object ppDBText10: TppDBText
        UserName = 'DBText4'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'StokFisiid'
        DataPipeline = ppSarfQ
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppSarfQ'
        mmHeight = 3440
        mmLeft = 2381
        mmTop = 529
        mmWidth = 15875
        BandType = 4
      end
    end
    object ppFooterBand2: TppFooterBand
      mmBottomOffset = 0
      mmHeight = 7144
      mmPrintPosition = 0
      object ppLine5: TppLine
        UserName = 'Line2'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Pen.Color = clGray
        Pen.Width = 2
        Weight = 1.500000000000000000
        mmHeight = 3969
        mmLeft = 1323
        mmTop = 5821
        mmWidth = 194734
        BandType = 8
      end
      object ppSystemVariable3: TppSystemVariable
        UserName = 'SystemVariable1'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        VarType = vtPrintDateTime
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 9
        Font.Style = []
        Transparent = True
        mmHeight = 3704
        mmLeft = 1588
        mmTop = 1323
        mmWidth = 26458
        BandType = 8
      end
      object ppSystemVariable4: TppSystemVariable
        UserName = 'SystemVariable2'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        VarType = vtPageNoDesc
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 9
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 3704
        mmLeft = 187537
        mmTop = 1323
        mmWidth = 8573
        BandType = 8
      end
    end
  end
  object RepDepoTransfer: TppReport
    AutoStop = False
    DataPipeline = ppDepoTransfer
    PrinterSetup.BinName = 'Default'
    PrinterSetup.DocumentName = 'Report'
    PrinterSetup.PaperName = 'A4'
    PrinterSetup.PrinterName = 'Default'
    PrinterSetup.mmMarginBottom = 6350
    PrinterSetup.mmMarginLeft = 6350
    PrinterSetup.mmMarginRight = 6350
    PrinterSetup.mmMarginTop = 6350
    PrinterSetup.mmPaperHeight = 297000
    PrinterSetup.mmPaperWidth = 210000
    PrinterSetup.PaperSize = 9
    Units = utMillimeters
    AllowPrintToFile = True
    DeviceType = 'Screen'
    EmailSettings.ReportFormat = 'PDF'
    OutlineSettings.CreateNode = False
    OutlineSettings.CreatePageNodes = False
    OutlineSettings.Enabled = False
    OutlineSettings.Visible = False
    PreviewFormSettings.WindowState = wsMaximized
    PreviewFormSettings.ZoomSetting = zs100Percent
    TextSearchSettings.DefaultString = '<FindText>'
    TextSearchSettings.Enabled = False
    Left = 784
    Top = 104
    Version = '10.02'
    mmColumnWidth = 197300
    DataPipelineName = 'ppDepoTransfer'
    object ppTitleBand3: TppTitleBand
      mmBottomOffset = 0
      mmHeight = 7938
      mmPrintPosition = 0
      object ppLabel13: TppLabel
        UserName = 'Label1'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Depo Transfer Fi'#351'leri'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 12
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4763
        mmLeft = 1323
        mmTop = 1323
        mmWidth = 59796
        BandType = 1
      end
    end
    object ppHeaderBand3: TppHeaderBand
      mmBottomOffset = 0
      mmHeight = 7408
      mmPrintPosition = 0
      object ppLine6: TppLine
        UserName = 'Line1'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Pen.Color = clNavy
        Pen.Width = 2
        Weight = 1.500000000000000000
        mmHeight = 3969
        mmLeft = 1323
        mmTop = 6350
        mmWidth = 194734
        BandType = 0
      end
      object ppLabel14: TppLabel
        UserName = 'Label2'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Stok Kodu'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Times New Roman'
        Font.Size = 10
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4233
        mmLeft = 19844
        mmTop = 1323
        mmWidth = 19579
        BandType = 0
      end
      object ppLabel15: TppLabel
        UserName = 'Label3'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Cinsi'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Times New Roman'
        Font.Size = 10
        Font.Style = [fsBold, fsItalic]
        Transparent = True
        mmHeight = 4233
        mmLeft = 61913
        mmTop = 1323
        mmWidth = 8731
        BandType = 0
      end
      object ppLabel16: TppLabel
        UserName = 'Label4'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Miktar'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Times New Roman'
        Font.Size = 10
        Font.Style = [fsBold, fsItalic]
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 4233
        mmLeft = 107950
        mmTop = 1323
        mmWidth = 12700
        BandType = 0
      end
      object ppLabel17: TppLabel
        UserName = 'Label5'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = #199#305'k'#305#351' Ambar'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Times New Roman'
        Font.Size = 10
        Font.Style = [fsBold, fsItalic]
        Transparent = True
        mmHeight = 4233
        mmLeft = 123296
        mmTop = 1323
        mmWidth = 20638
        BandType = 0
      end
      object ppLabel18: TppLabel
        UserName = 'Label6'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Fi'#351' No'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Times New Roman'
        Font.Size = 10
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4233
        mmLeft = 2117
        mmTop = 1323
        mmWidth = 16933
        BandType = 0
      end
      object ppLabel19: TppLabel
        UserName = 'Label19'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Giri'#351' Ambar'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Times New Roman'
        Font.Size = 10
        Font.Style = [fsBold, fsItalic]
        Transparent = True
        mmHeight = 4233
        mmLeft = 144463
        mmTop = 1323
        mmWidth = 20638
        BandType = 0
      end
    end
    object ppDetailBand3: TppDetailBand
      mmBottomOffset = 0
      mmHeight = 5027
      mmPrintPosition = 0
      object ppDBText11: TppDBText
        UserName = 'DBText1'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'stokkodu'
        DataPipeline = ppDepoTransfer
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDepoTransfer'
        mmHeight = 3440
        mmLeft = 19844
        mmTop = 529
        mmWidth = 40746
        BandType = 4
      end
      object ppDBText12: TppDBText
        UserName = 'DBText2'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'cinsi'
        DataPipeline = ppDepoTransfer
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDepoTransfer'
        mmHeight = 3440
        mmLeft = 61913
        mmTop = 529
        mmWidth = 40746
        BandType = 4
      end
      object ppDBText13: TppDBText
        UserName = 'DBText3'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'miktar'
        DataPipeline = ppDepoTransfer
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        DataPipelineName = 'ppDepoTransfer'
        mmHeight = 3440
        mmLeft = 103981
        mmTop = 529
        mmWidth = 16933
        BandType = 4
      end
      object ppDBText14: TppDBText
        UserName = 'DBText5'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'cambar'
        DataPipeline = ppDepoTransfer
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDepoTransfer'
        mmHeight = 3440
        mmLeft = 123296
        mmTop = 529
        mmWidth = 20373
        BandType = 4
      end
      object ppLine8: TppLine
        UserName = 'Line3'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Weight = 0.750000000000000000
        mmHeight = 529
        mmLeft = 1323
        mmTop = 4498
        mmWidth = 166688
        BandType = 4
      end
      object ppDBText15: TppDBText
        UserName = 'DBText4'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'StokFisiid'
        DataPipeline = ppDepoTransfer
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDepoTransfer'
        mmHeight = 3440
        mmLeft = 2381
        mmTop = 529
        mmWidth = 15875
        BandType = 4
      end
      object ppDBText16: TppDBText
        UserName = 'DBText16'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'gambar'
        DataPipeline = ppDepoTransfer
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDepoTransfer'
        mmHeight = 3440
        mmLeft = 144463
        mmTop = 529
        mmWidth = 21960
        BandType = 4
      end
    end
    object ppFooterBand3: TppFooterBand
      mmBottomOffset = 0
      mmHeight = 7144
      mmPrintPosition = 0
      object ppLine9: TppLine
        UserName = 'Line2'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Pen.Color = clGray
        Pen.Width = 2
        Weight = 1.500000000000000000
        mmHeight = 3969
        mmLeft = 1323
        mmTop = 5821
        mmWidth = 194734
        BandType = 8
      end
      object ppSystemVariable5: TppSystemVariable
        UserName = 'SystemVariable1'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        VarType = vtPrintDateTime
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 9
        Font.Style = []
        Transparent = True
        mmHeight = 3704
        mmLeft = 1323
        mmTop = 1323
        mmWidth = 26458
        BandType = 8
      end
      object ppSystemVariable6: TppSystemVariable
        UserName = 'SystemVariable2'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        VarType = vtPageNoDesc
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 9
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 3704
        mmLeft = 187537
        mmTop = 1323
        mmWidth = 8573
        BandType = 8
      end
    end
  end
  object UretimEskiQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <>
    SQL.Strings = (
      
        'select s.stokkod,s.stokkodu,s.cinsi,kalan=count(s.stokkod),po.de' +
        'pokod,depoadi=(select Depoadi from Depolar where Depolar.id=po.d' +
        'epokod),null as distakip into #yeni from pardeg p, parcaonay po ' +
        ', stok s'
      
        'where (p.onarimno=po.onarimno) and (s.stokkod=po.stokkod) and (p' +
        '.durum is null) and (p.yer is null) and not ((po.stokkod=po.ysto' +
        'kkod) and (po.cikdepo=po.depokod))'
      'group by s.stokkod,s.stokkodu,s.cinsi,p.durum,po.depokod'
      'union all'
      
        'select s.stokkod,s.stokkodu,s.cinsi,kalan=count(s.stokkod),po.de' +
        'pokod,depoadi=(select Depoadi from Depolar where Depolar.id=po.d' +
        'epokod),null as distakip from pardegSyok p, parcaonay po , stok ' +
        's'
      
        'where (p.belgeno=po.onarimno) and (s.stokkod=po.stokkod)  and (p' +
        '.durumu is null)  and not ((po.stokkod=po.ystokkod) and (po.cikd' +
        'epo=po.depokod))'
      'group by s.stokkod,s.stokkodu,s.cinsi,po.depokod'
      'union all'
      
        'select s.stokkod,s.stokkodu,s.cinsi,kalan=count(s.stokkod),po.de' +
        'pokod,depoadi=(select Depoadi from Depolar where Depolar.id=po.d' +
        'epokod),null as distakip from pardegSyok p, parcaonay po , stok ' +
        's'
      
        'where (p.belgeno=po.onarimno) and (s.stokkod=po.stokkod)  and (p' +
        '.durumu is null)  and not ((po.stokkod=po.ystokkod) and (po.cikd' +
        'epo=po.depokod))'
      'group by s.stokkod,s.stokkodu,s.cinsi,po.depokod'
      'union all'
      
        'select s.stokkod,s.stokkodu,s.cinsi,kalan=count(s.stokkod),po.ci' +
        'kdepo,depoadi=(select Depoadi from Depolar where Depolar.id=po.c' +
        'ikdepo),'#39'd'#39' as distakip from pardeg p, parcaonay po , stok s'
      
        'where (p.onarimno=po.onarimno) and (s.stokkod=po.ystokkod) and  ' +
        '(p.durum is null) and (p.yer='#39'E'#39')'
      'group by s.stokkod,s.stokkodu,s.cinsi,p.durum,po.cikdepo'
      'order by po.depokod,stokkodu'
      ''
      ''
      'select *,0 as  eklenen into #yeni2 from #yeni'
      ''
      'select * from #yeni2'
      ''
      'drop table #yeni'
      'drop table #yeni2')
    Left = 696
    Top = 209
  end
  object SarfEskiQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <>
    SQL.Strings = (
      
        'select s.stokkod,s.stokkodu,s.cinsi,kalan=count(s.stokkod),po.ci' +
        'kdepo,depoadi=(select Depoadi from Depolar where Depolar.id=po.c' +
        'ikdepo),null as distakip into #yeni from pardeg p, parcaonay po ' +
        ', stok s'
      
        'where (p.onarimno=po.onarimno) and (s.stokkod=po.ystokkod) and  ' +
        '(p.durum is null) and (p.yer is null) and not ((po.stokkod=po.ys' +
        'tokkod) and (po.cikdepo=po.depokod))'
      'group by s.stokkod,s.stokkodu,s.cinsi,p.durum,po.cikdepo'
      'union  all'
      
        'select s.stokkod,s.stokkodu,s.cinsi,kalan=count(s.stokkod),po.ci' +
        'kdepo,depoadi=(select Depoadi from Depolar where Depolar.id=po.c' +
        'ikdepo),null as distakip from pardegSyok p, parcaonay po , stok ' +
        's'
      
        'where (p.belgeno=po.onarimno) and (s.stokkod=po.ystokkod) and (p' +
        '.durumu is null)  and not ((po.stokkod=po.ystokkod) and (po.cikd' +
        'epo=po.depokod))'
      'group by s.stokkod,s.stokkodu,s.cinsi,po.cikdepo'
      'union  all'
      
        'select s.stokkod,s.stokkodu,s.cinsi,kalan=count(s.stokkod),po.de' +
        'pokod,depoadi=(select Depoadi from Depolar where Depolar.id=po.d' +
        'epokod),'#39'd'#39' as distakip from pardeg p, parcaonay po , stok s'
      
        'where (p.onarimno=po.onarimno) and (s.stokkod=po.stokkod) and (p' +
        '.durum is null) and (p.yer='#39'E'#39')'
      'group by s.stokkod,s.stokkodu,s.cinsi,p.durum,po.depokod'
      'order by po.cikdepo,stokkodu'
      ''
      ''
      'select *,0 as eklenen into #yeni2 from #yeni'
      ''
      'select * from #yeni2'
      ''
      'drop table #yeni'
      'drop table #yeni2')
    Left = 704
    Top = 281
  end
  object UpdatePardegsyok: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from pardegsyok'
      'where durumu is null')
    Left = 752
    Top = 296
  end
  object updatepardeg: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from pardeg'
      'where (durum is null) ')
    Left = 752
    Top = 264
  end
  object StokFisleriUpdateQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <
      item
        Name = 'islemzamani'
        Attributes = [paNullable]
        DataType = ftString
        NumericScale = 255
        Precision = 255
        Size = 12
        Value = Null
      end>
    SQL.Strings = (
      'update stokfisi'
      'set islemzamani=:islemzamani,aciklama=ozeltip,ozeltip=null '
      'where ozeltip is not null and ozeltip<>'#39'ekp'#39' and ozeltip<>'#39'arz'#39)
    Left = 752
    Top = 344
  end
  object UretimEskiQS: TDataSource
    DataSet = UretimEskiQ
    Left = 664
    Top = 208
  end
  object SarfEskiQS: TDataSource
    DataSet = SarfEskiQ
    Left = 656
    Top = 280
  end
end
